Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Doudou1
Contributor
Contributor
‎2023-01-20 04:41 AM

[Excel -> CSV] Get a dynamic schema from a source that has a fixed schema

hello everyone, I have a data source which is Excel and which has a schema which changes from one sheet to another, This file can have several sheets,

my problem is that I can't recover this data in a CSV file that I will use afterwards to feed a database

Attached the structure of my Excel file

Note: languages ​​change from one sheet to another

Thank you in advance for your help

Labels (5)
336 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2023-01-20 07:32 AM

I'm sorry, I am afraid we will need more of an explanation of the problem and what you have tried. However, if your sheet schemas are fixed, but your sheets are different within the Excel file, you can set up a component per sheet to achieve this. Have you tried that?

336 Views
0 Likes