How to Map each value with other Values

[Vinod]

Hi all

Source Table:

REG NO	VALUE
A1	20171103-E0023-0 20171110-E0023-0
B1	20161125-E0034-0 20171130-30022-0
C1	20170717-C0036-0 20180226-E0052-0
D1	20160510-E0049-0 20160519-C0043-0 20160527-E0056-0
E1	20170330-E0059-0 20170824-A0018-0 20170922-30011-0 20171025-E0039-0

Above I have created one table and in that tables i want to Map the REG NO with each value of the VALUE column. Means  I want output like below mentioned table.        

REG  NO	VALUE
A1	20171103-E0023-0
A1	20171110-E0023-0
B1	20161125-E0034-0
B1	20171130-30022-0
C1	20160510-E0049-0
C1	20160519-C0043-0
C1	20160527-E0056-0
D1	20160510-E0049-0
D1	20160519-C0043-0
D1	20160527-E0056-0
E1	20170330-E0059-0
E1	20170824-A0018-0
E1	20170922-30011-0
E1	20171025-E0039-0

Please anyone reply     

Regards,

Vinod              

[vishsaggi]

‌WHat is your source Excel, csv or SQL? What happens when you use straight Table or table box? Check and let me know?

[balabhaskarqlik]

Try below scenarios:

This is after data load

Region:

Load

[Reg No],

Value

from Region.csv;

NoConcatenate

Temp:

Load

    If(IsNull[Reg No],Above([Reg No]),[Reg No]) as [Reg No],

    Value

Resident Region;

Drop table Region;

OR

This is, at the time of data load, replace null row values with above row value.

Region:

LOAD [Reg No],

     Value

FROM [..\..\data\Edu\Data_03162012.xls]

    (biff, embedded labels, table is Sheet1$,

        filters(Replace(1, top, StrCnd(null))));

[Vinod]

My Source is Excel File. Actually i am new to QlikView. So Please explain all the scenarioa's with Excel,CSV and SQL.

[balabhaskarqlik]

Try like this:

From File wizard - Select Excel file - Next - Click - Enable transformation step - Click - Fill tab - Click on left side - Fill tab - Target Column(1 or 2 or... Column Number) - Cell Condition - Cell value - Is empty - OK, Fill Type - Above(Radio Button) - Ok - Next - Next - Check the script - Finish.

Run the script. Data reloaded.

[Vinod]

it's not working sir.

[balabhaskarqlik]

Did you tried like this:

This is after data load from excel:

Region:

Load

[Reg No],

Value

from Region.csv;

NoConcatenate

Temp:

Load

    If(IsNull[Reg No],Above([Reg No]),[Reg No]) as [Reg No],

    Value

Resident Region;

Drop table Region;

[Vinod]

I am having sample data.

Above table is my source table. I want to output like below table.

Please send me sample application.

[balabhaskarqlik]

May be like this:

Region:

Load

[Reg No],

Value

from Region.csv;

NoConcatenate

Temp:

Load

    & chr(10) & SubField([Reg No],' '3)  as [Reg No],   //Or below one

    Replace([Reg No],' ',chr(10)) as [Reg No],

    Value

Resident Region;

Drop table Region;

[Vinod]

I tried above code it is also not working sir. Please send me your application.