Hey,
I have a column which contains addresses. They are not cleaned. I have run a python script and the output looks something like the attachment,Addresses.txt (1.0 KB)
When i pivot them the order changes. (I need to pivot because i need to clean few types of addresses. There are 8M rows of data)
When i do the text cleansing, and I want to concat them, is there any way they can be concatted in the order they were before the pivot? Like add an index before pivot or something,
I think the problem is that you have different address headings for each entry. Therefore not every row after pivoting will contain the same information.
The order of the resulting columns is dependent on the information present in the first row. If on the Pivoting tab you deselect “Ignore domain”, the situation improves a bit, but the column order won’t apply to every row in your dataset.
I’m not sure this matters however. The String Manipulation node will allow you to join the contents of 2 string columns in whatever order you’d like.
If you really want to change the order of the columns, then the Column Resorter node allows you to do that.
Hey, I tried that but. the thing is…
Let’s say for some addresses it is like #235 xyz CA or for some it is abc #567 LA. So the numbers are in one column, state name in one column and the rest in another. After Pivot and Concat i want to maintain the order as per the input row. Can this be possible? Or it is just an impossible case. Right now the output for both is #235 cxy CA, #567 abc LA.
not sure I understand what is troubling you. Can you create workflow example and share it? From experience this is the fastest way to get help/solution/ideas. See here how to do that:
