Skip to main content

Qlik

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
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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: 
Chaitanyas
Contributor
Contributor
‎2017-04-27 11:55 AM

Create Multiple Tabs with single excel file based on the column

Hi Team,

 

I have requirement that I need to populate multiple sheets in single excel file based on Column.

 

Let me illustrate with an example I have members belongs to separate states and I need create a excel with the State name as tab and its associated members in each tab as a output.

 

Could you please help me in providing the solution, that how do we achieve in Talend. Right now we are using SAP Crystal Report to populate such type of files.

 

Thanks In-advance.

 

Regards,

Chaitanya

Labels (2)
Labels
790 Views
0 Likes
20 Replies
14
Contributor
Contributor
‎2019-06-11 05:40 AM

HI,

I have xlsx file with 14 tabs and each are with different meta data. I need to combine all sheet records into 1 common record based on id column. i am facing problem when i am combining the data, because all are having different meta data.

 

Please help me on this

104 Views
0 Likes