The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Everyone,
I have three excel files with different structures. See below.
Table : 1
AuditID TransactionID Date Name XXX XYZ
Table : 2
AuditID TransactionID Date Name YYY
Table : 3
AuditID TransactionID Date Name ZAAA ZBBB ZCCC
Output
AuditID TransactionID Date Activity Activity_Value
The Activity column has all the non-matched column names from the above 3 tables, the Activity_Value column has the values of it.
How do i achieve this? The structure of the excel files will be changed on a daily basis.
With SSIS foreachloop, we can't achieve this because of non-matched columns of all the excel files. Any other solution for this?
Thanks in advance,
Pradeep
Solved! Go to Solution.
Hi @Anonymous,
In your scenario, as these tables will have the same columns: AuditID TransactionID Date Name. You can append these tables, then use Unpivot Columns feature based on columns AuditID TransactionID Date Name.
Best Regards,
Qiuyun Yu
Hi @Anonymous,
In your scenario, as these tables will have the same columns: AuditID TransactionID Date Name. You can append these tables, then use Unpivot Columns feature based on columns AuditID TransactionID Date Name.
Best Regards,
Qiuyun Yu
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |