Eliminate 'Warning: Input Data (1): There were multiple fields named ...'

[SurferJim]

Hello, thanks in advance for your help.

I am using Jira and the export file has multiple columns of the same header name.  I can't find a way to get around the Warning that multiple fields name in the input file  There was a post using the Dynamic Rename tool but it only works on the header but not the first row which contains the header name (at least my understanding).  Keep in mind that there can be any number of "Type" columns.

I will be transposing the data anyway so I was thinking of renaming the "Type" columns to  "Type" with number since there's no telling of how many "Type" columns the file will have.  After the transpose I no longer need the "Type" header

Input:

ID	Title	Type	Type	Type	Type
1	Title1	A
2	Title2	A	B
3	Title3	B	C	D	E

After Transpose:

ID	Name	Value
1	Title1	A
2	Title2	A
2	Title2	B
3	Title3	B
3	Title3	C
3	Title3	D
3	Title3	E

[bcastro1991]

Hello,

One thing you might be able to try, if on each import, the header is always on X row (for example, row 1 is a title of the export, then row 2 is your header names), you can update the Input tool config for "Start Data Import on Line" from 1 to 2, or whatever row your data starts on, then leverage the Dynamic Rename and doing your transposing after that. If you are using the Dynamic Input tool to open multiple files, your template you set up in that tool can also use this same configuration.

Let me know if this helps!

[danilang]

Hi @SurferJim 

You can use something like this to eliminate the warnings and still give you the output you want

The Input tool is configured to treat the first row as data.  It then builds incremental field names without generating the warnings.  Follow this with a Dynamic Rename which configured to "Take field names from first row of data", but only for the first two columns.  Then Transpose and cleanup.  The results look like this with no warnings

 

Note that this is using the standard Input Data connector.   I've never used the Jira Connector, so I don't know if there is a similar option to use the first row as data. 

Dan

[SurferJim · Accepted solution]

Nice.  Thanks all.