Different inputfiles

[mtp1]

Dear all,

I am new and an absolute beginner - I have a very conceptual question:

I have two files with following column names:

1: A/B/C/D/E

2: F/G/H/I/J

I want to do the following: 

File 1 I want to summarize for values in Column D

File 2 I want to summarize for values in Column J

And I want (first) rename those columns to "K"

Is it possible to do this in one workflow in order to run this workflow two times (with both files) getting the "same output -> sum of "K"?

Any suggestions?

[atcodedog05]

Hi @mtp1 

I just got a rough idea of your expectation. But i think its possible. Can you provide files if thats ok.

Right now i will prep one with sample data.

[mtp1]

Thanks for your response.

So far no files available. Are you able to help me out without files?

Best,

Pascal

[atcodedog05]

Hi @mtp1 

Please check this workflow is this what you are looking for.

If not give me more info i can help you out.

Hope this helps 🙂

[mtp1]

Hi,

Thanks for your help. Is it possible to "combine" these two workflows?

I am asking for a single workflow to detect if there is a column named "D" or "J" and in case there is I want it to be renamed to "K" and then put the sum formula.

Examples:

Third column is named "D" -> rename third column to "K" and summarize

Seventh column is named "D" -> rename seventh column to "K" and summarize

Second column is named "K" -> rename second column to "K" and summarize

Nineth column is named "K" -> rename ninth column to "K" and summarize

It should look for a list of names (here: "D" and "J") and in case there is such a column this column should be summarized.

[grazitti_sapna]

HI @mtp1 , is this what you are trying to achieve?

If this is what you are looking for, kindly mark this post as solution.

Thanks