topic Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common field in QlikView

Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common field

vsr_shimla — Sat, 16 Nov 2024 19:59:09 GMT

Dear All,

Pls help,

I have uploaded the transactional data of 2 Different Movements from a single factory.

1. Raw material (Inbound)

2. Finished Product (Outbound)

I want to analyse the Vehicles(TrnsIDCode) loading Finished Product from the factory within 3 Days of bringing Raw Material then a Flag is required in the script.

Thanks in advance.

Re: Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common fi

Arthur_Fong — Mon, 30 Sep 2019 08:35:50 GMT

IMHO your Finished Data requires [Posting Date] column to identify:

When did the RawMat arrives at the Factory.

Then you may join both tables using [Posting Date] and [TransIDCode] as Key.

Do attached a new Excel file when you have the required column ready.

Re: Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common fi

vsr_shimla — Mon, 30 Sep 2019 09:05:37 GMT

[Posting Date]= Arrival date or unloading date

Re: Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common fi

sk88024 — Mon, 30 Sep 2019 09:12:46 GMT

Hi,

The data set looks incomplete since it does not implicate anything on Finished Product. It requires at least a column for Date of Finished Product .

/SK

Re: Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common fi

sk88024 — Mon, 30 Sep 2019 09:14:52 GMT

what about loading date?

Re: Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common fi

vsr_shimla — Mon, 30 Sep 2019 09:28:34 GMT

Hi, Thanks for your time,

The [Actual GI date] in Finished sheet is the Date of removal of the Finished product.

The [Posting date] in RawMat is also the unloading/Arrival date/removal of Product

There is no relation required between the Raw material & Finished product as they are not related.

The relation I require between the two is that If a Raw material Truck carried finished product on its way out within 3 days of [Posting date].

Hope I am able to explain

rgds

Re: Joining transactional data of 2 Different Products with only Vehicle (TrnsIDCode) as a common fi

vsr_shimla — Fri, 11 Oct 2019 05:57:41 GMT

Dear experts,

Pls help solving my problem.