topic Re: Merging Data Without Key in QlikView

Merging Data Without Key

mbespartochnyy — Tue, 28 Mar 2017 20:46:52 GMT

Hello everyone,

I'm working with a data set that is in unusual format (see Sheet1 in attached spreadsheet). I am trying to load Data from Sheet1 and make it look like data in Sheet2.

I am able to load Reference (Column B) through Check number (Column N), but I'm having trouble bringing Vendor, Company Code, Name, and City fields which are above each set of data.

Attached is a QVW that I have so far. It Brings in the data from Columns B-N and list of Vendors, Company Codes, Vendor Names, and Cities from the data set but doesn't link the two tables.

The rules of data is that a table with data will always follow supplier info.

Does anyone have any suggestions how this data can be transformed and joined?

Thanks,

Mikhail Bespartochnyy

Re: Merging Data Without Key

ahaahaaha — Wed, 29 Mar 2017 08:11:45 GMT

Hi Mikhail,

As an variant, an example in the attached file.

Result

Regards,

Andrey

Re: Merging Data Without Key

mbespartochnyy — Wed, 29 Mar 2017 13:44:32 GMT

Thanks, Andrey! That solution works for a small data set, however, I'm working with a spreadsheet with close to 1,000,000 lines. A client that I'm working with is expected to provide additional spreadsheets with about 200,000 lines each month. I was hoping there might be a more automated way to process and load the data.

Mikhail B.

Re: Merging Data Without Key

sunny_talwar — Wed, 29 Mar 2017 14:09:06 GMT

Check if the attached is automated enough

Re: Merging Data Without Key

mbespartochnyy — Sat, 08 Apr 2017 20:07:43 GMT

Forgot to mark this correct but this did the trick! It worked perfectly on the entire data set. Thanks, Sunny!

Mikhail B.