Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedJoin us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Fabric update to learn about new features.
User | Count |
---|---|
6 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
13 | |
10 | |
5 | |
5 | |
4 |