Out Put is not comes as desired

[madhubabum]

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

[petter]

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...

[madhubabum]

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

[SreeniJD]

Hi Madhu,

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

Regards,

Sreeni

[petter]

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?

[madhubabum]

Hi Petter Skjolden

Thanks for your reply

I need all the Fields information in qlikview