topic Re: This is the input and output in QlikView

This is the input and output

srimanta — Mon, 15 May 2023 12:48:00 GMT

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

Re: This is the input and output

Kushal_Chawda — Mon, 15 May 2023 15:13:39 GMT

@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 ];

Re: This is the input and output

srimanta — Tue, 16 May 2023 05:22:14 GMT

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

Re: This is the input and output

Kushal_Chawda — Tue, 16 May 2023 12:13:52 GMT

@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?

Re: This is the input and output

srimanta — Wed, 17 May 2023 04:29:10 GMT

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