07-13-2022 02:34 PM
Hi,
I tried creating an MV using Incorta SQL as Data Source, but I keep getting below error as shown below. Can you help me understand when to use this particular type in creating MV's.
INC_04030340: Materializing table failed because 109152
Thanks,
Srini
Solved! Go to Solution.
08-12-2022 10:16 PM
Can you try use the CONCAT() SQL function?
SELECT A.X1, A.X2, B.X4, B.X5
FROM table1 A
LEFT JOIN table2 B
ON A.X1 = concat(B.X2,'.',B.X3)
08-15-2022 07:54 AM
Did you try using concat() or "+" for your concatenation operator?