Forum Discussion
Bulk multi data export to Excel
Ok, i have now worked out how to extract the data which is good, however, it has combined all the data in 1 list and i really need to keep the format separated so each race is still in a format recognisable to that race with the split between each race.
Hi dolfinco2,
A more elegant solution would be to connect to a folder that contains your CSV files and use the filenames as your identifier. Just Imagine having 100 CSVs, you wouldn't want to append them one by one.
But since you've already appended your queries, add a custom column to each query. You can name it as Identifier and in the formula field of the Add Column dialogue box, enter a text to identify your query with enclosed in quotation marks say "Query 1". This will add a column which value for each row is "Query 1".
Thanks for this and i like it as it gives me an additional functionality of adding date, race and class which is soemthing i have to to externally at present.
However, when i add these fields in on the front page it does this:
Then when i go to edit the query, the additional new columns dont pull through ??
What I meant was add a column in the query editor and not create a calculated column in DAX.
Please download a sample PBIX from the link below.
https://drive.google.com/open?id=17ILzYtoI7ORtCyAAMPXhuR2uwucZV-RM
Open the file, then click Edi Queries. You will see in the file that I have added a custom column which is used as as an identifer.