SmithToronto
New Member
- Joined
- Feb 3, 2021
- Messages
- 2
- Office Version
- 2016
Hi,
I have following Excel data. How I can get the desired result in D2,D3 and D4 columns. If any column has NULL or blank then values should be '' in Insert command, as mentioned in the D columns
A1 B1 C1
1 E AAA
2 E BBB
3
A1 B1 C1 D1
1 E AAA Insert into TPG (A1, B1, C1) values ((Select max(A1)+1 from DIC),'E','AAA')
2 E BBB Insert into TPG (A1, B1, C1) values ((Select max(A1)+2 from DIC),'E','AAA')
3 Insert into TPG (A1, B1, C1) values ((Select max(A1)+3 from DIC),'','')
I have following Excel data. How I can get the desired result in D2,D3 and D4 columns. If any column has NULL or blank then values should be '' in Insert command, as mentioned in the D columns
A1 B1 C1
1 E AAA
2 E BBB
3
A1 B1 C1 D1
1 E AAA Insert into TPG (A1, B1, C1) values ((Select max(A1)+1 from DIC),'E','AAA')
2 E BBB Insert into TPG (A1, B1, C1) values ((Select max(A1)+2 from DIC),'E','AAA')
3 Insert into TPG (A1, B1, C1) values ((Select max(A1)+3 from DIC),'','')