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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
srimanta
Contributor II
Contributor II

This is the input and output

Input:

Student:
Load * Inline [
Empno, EName, Salary, Location
101, Ram, 50000, India
102, Mohan, 60000, USA
103, Sam, 82000, Germany
104, Abhisek , 72000, Poland

];

Output:

Ram is From India
Ram's Salary is 50000

Mohan is From USA
Mohan Salary is 60000

Sam is From Germany
Sam Salary is 82000

Abhishek is From Poland
Abhiseka Salary is 72000

 

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@srimanta  try below

Load *, EName & ' is from ' & Location & chr(10) & EName & chr(39) &'s' & ' Salary is ' & Salary as TEXT  
Inline [
Empno, EName, Salary, Location
101, Ram, 50000, India
102, Mohan, 60000, USA
103, Sam, 82000, Germany
104, Abhisek , 72000, Poland

];

View solution in original post

4 Replies
Kushal_Chawda

@srimanta  try below

Load *, EName & ' is from ' & Location & chr(10) & EName & chr(39) &'s' & ' Salary is ' & Salary as TEXT  
Inline [
Empno, EName, Salary, Location
101, Ram, 50000, India
102, Mohan, 60000, USA
103, Sam, 82000, Germany
104, Abhisek , 72000, Poland

];
srimanta
Contributor II
Contributor II
Author

Thank u soo much....but can you please solve this by using For Loop.

Kushal_Chawda

@srimanta  I would not recommend to use for loop unless it is really necessary. Can you tell me why you need to use for loop?

srimanta
Contributor II
Contributor II
Author

I want to know what is the different way to solve this type of problem.....