Forum Discussion

Kusi's avatar
Kusi
New Contributor
5 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
Kusi's avatar
Kusi
New Contributor
5 months ago

To clarify on the ask:

1. I need the table to insert two new lines per [PROJ_ID] column. 

1.a. The original line will have 'project currency' in the [CURRENCY] column

1.b. The two new lines should have 'entity currency' and 'group currency' respectively.

 

Currently, this just inserts one line per [PROJ_ID] and adds nothing to the [CURRENCY] column