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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exporting records into files

incase i have 10000 records and i want to export 2000 records into one file and 4000 Records into another File? How can we export records separately?
Labels (1)
  • Other

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Add a sequence id for each row if there is no sequence id in source data, and use this sequence id to filter the rows.
To do: (for example)
tFileInputDelimited--tMap1-out1--tfile1
-out2--tfile2
Hope it helps you!

Regards
Shong

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hi 

Do you want to filter the records based on condition or just random output the records in a file?

 

Regards

Shong

Anonymous
Not applicable
Author

just a random output records of a file which is exported into separate
files.
Anonymous
Not applicable
Author

Add a sequence id for each row if there is no sequence id in source data, and use this sequence id to filter the rows.
To do: (for example)
tFileInputDelimited--tMap1-out1--tfile1
-out2--tfile2
Hope it helps you!

Regards
Shong
Anonymous
Not applicable
Author

Thanks a lot👍🏽👍🏽👍🏽