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: 
vkish16161
Creator III
Creator III
‎2018-12-05 03:53 PM

Can anyone please explain what this code does?

A:
load * inline [
A,B
Dummy
East,1];

 

EmptyRowsMapper:
MAPPING
LOAD
null() AS From,
'' AS To
AutoGenerate 1;

MAP * Using EmptyRowsMapper;

 

Can anyone please explain what this code does?

678 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2018-12-06 12:32 AM

Just to replace duplicate null values to real null values to show '-' instead 'String'
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
647 Views
marcus_sommer
MVP
MVP
‎2018-12-06 03:53 AM

Here it's well explained: qlikviewcookbook - filling-default-values-using-mapping.

- Marcus

638 Views