The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have some template files, each with different column names. And users may need to customize new files with exsting tempaltes by combination randomly. Here is my design:
I create a delta table containing all the columns of all template fiels and define all the columns mapping in one file like below:
{
"type": "TabularTranslator",
"mappings": [
{
"source": {
"name": "T1_F1",
"type": "String",
"physicalType": "String"
},
"sink": {
"name": "A_1",
"physicalType": "string"
}
},
{
"source": {
"name": "T1_F2",
"type": "String",
"physicalType": "String"
},
"sink": {
"name": "A_2",
"physicalType": "string"
}
},
{
"source": {
"name": "T2_F1",
"type": "String",
"physicalType": "String"
},
"sink": {
"name": "B_1",
"physicalType": "string"
}
},
{
"source": {
"name": "T2_F2",
"type": "String",
"physicalType": "String"
},
"sink": {
"name": "B_2",
"physicalType": "string"
}
}
],
"typeConversion": true,
"typeConversionSettings": {
"allowDataTruncation": true,
"treatBooleanAsNumber": false
}
}
and put it in the paramtere for the Fabric pipeline with parameter key"mapping" as below
And define the dynamic mapping as below:
I can copy the files with ALL columns defined in the prediffined-mapping. But failed with any file with only partial columns.
Take the example above, I can copy copy files with columns "T1_F1" ,"T1_F2","T2_F1" and "T2_F2".
But I CAN NOT copy file with only "T1_F1" and "T1_F2"
How to do solve this?
Hi @Winnie2024
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks
Hi @Winnie2024
Can you please confirm what is the error you are getting? A screenshot would help.
Thanks
Hi @Winnie2024
We haven’t heard from you on the last response and was just checking back to see if you can provide the details asked above.
Thanks
Hi @Winnie2024
We haven’t heard from you on the last response and was just checking back to see if you can provide the details asked above.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
2 | |
2 | |
2 |