topic Re: Out Put is not comes as desired in QlikView

Out Put is not comes as desired

madhubabum — Mon, 12 Oct 2015 15:04:28 GMT

Hi Experts

Step : 1

--> I am having Excel files in a Folder (Using For Each Loop to fetch the data)

step : 2

--> I want to add a field as Employee Site to the Cell A5

step : 3

--> adding Employee Progress Details (Left Joined)

OutPut:

note :1

In our Excel files having total 40 records , But it will showing as 57 records

note :2

Error Details showing Wrong Information (Only Book3 doesn't have Emp_Id details)

i.e Book5, Book6 have the Emp_Id details

Here , I am attaching the Application,Excel files,OutPut files

How , we can achieve this scenario ?

Thanks

Madhu

Re: Out Put is not comes as desired

petter — Mon, 12 Oct 2015 16:14:36 GMT

A hint - a left join might increase the number of rows if the left-table-join-key-value results in a match with more than one row for the right-table-key-value ...

So getting 57 rows instead of 40 rows might not be so strange after all...

Re: Out Put is not comes as desired

madhubabum — Tue, 13 Oct 2015 06:10:31 GMT

Hi Petter Skjolden

Thanks for your reply

What will be the better approach ? (Please Suggest to me ) Is any Idea to solve this Issue .

Thanks

Madhu

Re: Out Put is not comes as desired

SreeniJD — Tue, 13 Oct 2015 06:12:55 GMT

Hi Madhu,

See, if you can use ApplyMap() which is always better than left join.

Regards,

Sreeni

Re: Out Put is not comes as desired

petter — Tue, 13 Oct 2015 06:21:30 GMT

You could make sure that you aggregate the rows from the right-most-table to the level of the left-most-table by doing a group by and then doing the left join.

Having had a quick look at your files I see that you will have to decide on a data model - how does all this raw data from spreadsheet really fit together and specifically what kind of table structure and fields are necessary for your QlikView application?

Re: Out Put is not comes as desired

madhubabum — Tue, 13 Oct 2015 07:55:34 GMT

Hi Petter Skjolden

Thanks for your reply

I need all the Fields information in qlikview