Forum Discussion

Kusi's avatar
Kusi
New Contributor
7 months ago

Extensibility Rules - SQL - Custom Data Tables

This syntax only inserts one line and the line does not have 'entity currency' or 'group currency' description in the [currency] column. Please advise on what the issue could be: INSERT INTO XFC_0...
Data Integration
DanielWillis's avatar
DanielWillis
Valued Contributor
7 months ago

The above is a bit confusing to me, both the SQL and the requirement. Perhaps only because a bit more understanding of the data is required.

I wonder if you tried to do this in 3 separate insert statements you either get there a lot easier and can then either make a decision on whether to keep it as 3 inserts or find out your logic is a lot simpler and you can bring them back together.