How to resolve truncate issue and get required product id by joining two tables

[Anjankumar2021]

Hi Team,

@binuacs 

Please assist on the below issue.

want to get product ID based on Series_LG. i have applied join tool but cell data is truncated . Hence not able to get required results.

Input
Table A
Product ID	TV Series
897935 (LG)	76885352.1.9999(LG), 76885367.1.9999(LG), 76840736.1.9999(LG), 76885344.1.9999(LG), 76840734.1.9999(LG), 76872822.1.9999(LG)
452772 (LG)	76395965.1.9999(LG), 76336122.1.9999(LG), 76345238.1.9999(LG), 76336251.1.9999(LG), 76336258.1.9999(LG), 76336138.1.9999(LG), 76336189.1.9999(LG), 76421817.1.9999(LG)
8645798 (LG)	74921344.1.9999(LG), 74927964.1.9999(LG)
9525088 (LG)	76454312.1.9999(LG), 76454409.1.9999(LG), 76454533.1.9999(LG), 76454526.1.9999(LG), 76454130.1.9999(LG), 76454470.1.9999(LG), 76454259.1.9999(LG), 76454550.1.9999(LG), 76454186.1.9999(LG), 76454294.1.9999(LG), 76454413.1.9999(LG), 74880169.1.9999(LG), 76454146.1.9999(LG), 76454383.1.9999(LG), 76454320.1.9999(LG), 76454279.1.9999(LG), 76454476.1.9999(LG), 76489129.1.9999(LG), 74903119.1.9999(LG), 76454127.1.9999(LG), 76454267.1.9999(LG), 74879987.1.9999(LG), 76454195.1.9999(LG), 76454440.1.9999(LG), 76454258.1.9999(LG), 76454411.1.9999(LG), 76454225.1.9999(LG), 76454441.1.9999(LG), 76454390.1.9999(LG), 76454184.1.9999(LG), 76454439.1.9999(LG), 76454281.1.9999(LG), 76454227.1.9999(LG), 76454516.1.9999(LG), 76454252.1.9999(LG), 76454311.1.9999(LG), 76454329.1.9999(LG), 76454341.1.9999(LG), 76454255.1.9999(LG), 76454438.1.9999(LG), 76454306.1.9999(LG), 76454351.1.9999(LG), 76454432.1.9999(LG), 76454429.1.9999(LG), 76454396.1.9999(LG), 76454346.1.9999(LG), 76454430.1.9999(LG), 76454340.1.9999(LG), 76454448.1.9999(LG), 76454389.1.9999(LG), 76454168.1.9999(LG), 76454307.1.9999(LG), 76464377.1.9999(LG), 76454449.1.9999(LG), 76454347.1.9999(LG), 76454313.1.9999(LG), 76454386.1.9999(LG), 76454524.1.9999(LG), 76454423.1.9999(LG), 76454479.1.9999(LG), 76454385.1.9999(LG), 76454464.1.9999(LG), 76454182.1.9999(LG), 748874.1.9999(LG), 76454202.1.9999(LG), 74879999.1.9999(LG), 76454387.1.9999(LG), 76454404.1.9999(LG), 76454218.1.9999(LG), 76454143.1.9999(LG), 748832.1.9999(LG), 748843.1.9999(LG), 76454328.1.9999(LG), 76454380.1.9999(LG), 76454224.1.9999(LG), 76454382.1.9999(LG), 76454491.1.9999(LG), 76454278.1.9999(LG)
198999750 (LG)	75910119.1.9999(LG), 75926632.1.9999(LG), 75910387.1.9999(LG), 75909933.1.9999(LG), 75910112.1.9999(LG), 759117.1.9999(LG), 75910143.1.9999(LG), 75910250.1.9999(LG), 75909985.1.9999(LG)

Table-B
Series_LG
0076840736
0076421817
0074921344
0076454168
0075909985

Required OUTPUT:

Output
Series_LG	Product ID
76840736	897935
76421817	452772
74921344	8645798
76454168	9525088
75909985	8999750

[apathetichell]

I'd recommend going through on the online Alteryx trainings. Start from the beginning. To solve your issues - you'll split tv series to rows (probably /n as a delimeter) and then you'll clean your data so that you remove the leading 0's in one data source and everything after the . in the other... you can use regex.

you can then join.

[Anjankumar2021]

I have applied text to column with delimiter but not able to get required result for TV Series. after applying delimiter except first line in the cell "76885352"remaining got truncated in the Cell.  Hence i got below output

Series_LG	Product ID
76840736
76421817
74921344	8645798
76454168
75909985

[binuacs · Accepted solution]

@Anjankumar2021 use the find and replace tool or join tool, 

[Anjankumar2021]

@binuacs thanks for your reply.

i want to include if Series _LG not found for respective product ID.

in this case i need to use Join tool instead of find and replace.

kindly assist

[binuacs]

@Anjankumar2021, it should display as a null value in the Find and Replace tool. are you not seeing it?