1 Reply Latest reply on May 28, 2018 3:00 AM by Chris McClellan

Populate data in column ,based on condition in rows

Venkata Srinivasa Rao Talatam May 27, 2018 10:04 PM

Hi All,

I am trying to replicate the scenario ,where i want to get the Materiel location based on condition - like Materiel type - "F" or "T".

The value of the Material Locations in 2 to 3 rows - 1 row contains the materail type "F" and other Row contains Materiel Type "T".

I want to show each row which populate the data based on Material type.

Attaching the sample data. which contains 2 tabs - Input and expected output.

Can you please help.

Regards,
Venkat

1. Re: Populate data in column ,based on condition in rows

Chris McClellan May 28, 2018 3:00 AM (in response to Venkata Srinivasa Rao Talatam)

Is there another field (like Order No ?) that can be used to join the data together ?

I think I can do it based on the data that you have, but it won't be perfect all the time - like how does the last line (quantity = 10) link to the -100 row ? (I just don't understand that)
Like Show 0 Likes(0)

Actions

Tableau Community Forums