How to make column name identical

[geop31794]

Files are generated only on weekdays having same underline data structure and filename format is ABC_Date(YYYYMMDD). I wanted to create an analytical app that will dynamically select the files basis on user startdate and enddate input. Files underlying data structure and filename format is ABC_Date(YYYYMMDD).

Eg : User has selected startDate : 20200505 and endDate : 20200512, then read all the file between this two date and generate output as below

Input:

File Name : ABC_20200505

Ledger	T-1
A	10
B	20
C	30
D	40

Output:

Ledger	T-1	T-1	T-1	T-1	T-1	T-1
	20200505	20200506	20200507	20200508	20200511	20200512
A	10	20	10	20	10	20
B	20	20	20	20	20	20
C	30	30	30	30	30	30
D	40	40	40	40	40	40

I have created an analytic app but I don't know how can I make column name Identical as per mentioned in the output. I would also love if there is any optimized solution.

[DavidP · Accepted solution]

Simple answer is that you can't have columns with the same name - they have to be unique.

But you can create a dataset with column names like this, and skip the column names when writing to Excel, for instance.

1	2	3	4		6	7
Ledger	T-1	T-1	T-1	T-1	T-1	T-1
	20200505	20200506	20200507	20200508	20200511	20200512
A	10	20	10	20	10	20
B	20	20	20	20	20	20
C	30	30	30	30	30	30
D	40	40	40	40	40	40

[geop31794]

Hi @DavidP ,

This worked for me. I didn't think about this angle as mentioned by you. Thank you. God bless you.