Common transformations

[#1]

Hi,

What are the most common or generic transformations involved in most of projects in case of three layer architecture, below are some

examples I think, please add more

concatenate,interval match,applymap(),aggregation,join, keep,peek

[sunny_talwar]

• There is CrossTable load to load pivot table and Generic load to do the opposite of CrossTable.
• You mentioned Peek, there is also Previous
• Their is Hierarchy Load
• You mentioned ApplyMap(), there is MapSubString()

I guess you can look on the help section to find many more functions like this:

Functions in scripts and chart expressions ‒ QlikView