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              

[tamilarasu]

Great Vinod Sir. Please close the thread by marking correct and helpful answers. Have a nice week!!

[Vinod]

Hi sir,

In my output some values are displaying two times.

[tamilarasu]

Could you post snapshot of input and wrong output?

[Vinod]

FTR NO of Reg No-D and F are showing two times in output.

[tamilarasu]

I am not able to replicate the issue. Could you please attach the excel file here?

Note: Don't use your inbox option to post a sample file. It will not show the attach option. For more details, please have a look at the below link.

Uploading a Sample

[Anil_Babu_Samineni]

I believe DISTINCT will resolve this time?

If below one is working then just add DISTINCT to LOAD statement?

Data: 

LOAD  DISTINCT

[REG NO], 

SubField(VALUE, CHR(10)) as VALUE 

From Excel;

[tamilarasu]

Anil - I want to know the reason for duplicate issue. Let us wait for the sample file.

[Vinod]

I can't see the Use advanced Editor option on my scrren.

[Vinod]

Whatever the screen shot i shown above that is excel data source. Please check and clarify me.

Thanks,

Vinod

[Vinod]

Ok. I will send u.