Alteryx Pasting the output data in next available column.

[akumar2609]

Hi...
I am looking for a solution for my query. There is a process which I need to run from 1st to 10th of every month. I need the output data to be written one after another depends upon the empty column. For example

On Day 1, I get the below output.

Column A      Column B     Column C

Country                Sell              Profit

US                        XYZ             XYZ

Japan                   XYZ             XYZ  

On Day 2, I need alteryx to paste the data from Column D (as this is empty at this point of time). So My output should be like previous day data (from col A to C) and today's data (from col D to F):-                     

Column A      Column B     Column C        Column D          Column E       Column F

Country                Sell              Profit             Country                Sell                Profit  

US                        XYZ             XYZ              Aus                     XYZ                 XYZ

Japan                   XYZ             XYZ              NZ                      XYZ                 XYZ

                                                                      India                   XYZ                 XYZ

On Day3, I need alteryx to paste the data from column G onwards as this is empty. Like this, I want all my data to be pasted one after another in empty columns.

[akumar2609]

Hi...
I am looking for a solution for my query. There is a process which I need to run from 1st to 10th of every month. I need the output data to be written one after another depends upon the empty column. For example

On Day 1, I get the below output.

Column A      Column B     Column C

Country                Sell              Profit

US                        XYZ             XYZ

Japan                   XYZ             XYZ  

On Day 2, I need alteryx to paste the data from Column D (as this is empty at this point of time). So My output should be like previous day data (from col A to C) and today's data (from col D to F):-                     

Column A      Column B     Column C        Column D          Column E       Column F

Country                Sell              Profit             Country                Sell                Profit  

US                        XYZ             XYZ              Aus                     XYZ                 XYZ

Japan                   XYZ             XYZ              NZ                      XYZ                 XYZ

                                                                      India                   XYZ                 XYZ

On Day3, I need alteryx to paste the data from column G onwards as this is empty. Like this, I want all my data to be pasted one after another in empty columns.

[cjaneczko]

What is the relationship between Column A US and Column D Aus? Typically the data would be structured to stack the countries in the same column unless there is some relationship between column A and Column D.

[akumar2609]

As such there is no relation between these two columns. All I know is that every time I will get only three columns per day as output. And my requirement is to have those details one after another.