Filter

[Thiviya]

Hi,

From the raw data I would like to select only the BU's that are in the keywords. How do I do it ?

[flying008]

Hi, @Thiviya 

There is no input data in your flow, maybe you can upload sample data of input and output as your want.

[Thiviya]

Sorry, attached the workflow . The orignal source data is coming from L_PC Projects.

Thanks

[flying008]

You need upload the L_PC_PROJECTS_1219966301.xlsx together or use text input as data source.

[Thiviya]

Sorry can you please clarify what do you mean need to upload together.

I have uploaded the source data, from that only selected relevant columns. From the columns selected for the field " GL unit" I would like to make sure only select the B GL unit form the " Key words". How do i do that?

Are you able to show that in the workflow I have sent.

Thanks

[flying008]

Because you have the input file of LPC*.xlsx , but i have not, so i can't open the flow repeat your process.

[Thiviya]

 I have attached the original following files :

L_PC - source input and key words

Are you able to check the flow ?

[flying008]

I may still not quite understand your requirements, this is just an example.

[Thiviya]

Thank you for your help. That's really helpful demonstration.

I have added these and able to look at the details.

How do I update to choose only certain things from the " project category"?

Also, for the end results how do I add another three more columns? 

[Thiviya]

How do I update to choose only certain things from the " project category"?

Also, for the end results how do I add another three more columns?