Different data in a Same Sheet using RANGE formula

Question

Hello Everyone,

I am trying to write 4 different outputs in a same sheet, but its generating it in incorrect format.

I have tried using Range formula, first 3 data populated correctly, but the 4th data is getting misplace.

Pls have a look at the screenshot and also find the workflow I attached for easier access to get the solution from you.

Sample.yxmd

RANGE.PNG

apathetichell · Answer

My hunch is you are writing range as B:B vs b2:b5... If you are overwriting a range potentially with fewer values than are currently on the sheet - you must declare a beginning and an ending to your range. In your case - I believe you are writing over 1 row - but the other rows from your original sheet are kept in your ouput. Can't really tell though with what you've uploaded. .yxzp would help diagnose this.

davidskaife · Answer

Hi @Sarath27

Thinking outside the box slightly but this works;

Join the streams on record position, and Union in any that are missed (due to it only joining the same number of rows). The final output uses named range of rows 2 - 9 which you would need to expand on if you have more data. The config for the Output Data tool is below and workflow attached:

Range.yxmd

aatalai · Answer

@Sarath27 can you try using the table tool (one for each current output) and formatting the output that way?