Returns the Cartesian product of the sets of records from two or more joined datasets.
Version 1
HTTP RequestPOST /ado/v1/CartesianJoin
Header
| Parameter | Description |
|---|---|
| Ocp-Apim-Subscription-Key | The subscription key you received when you purchased a plan. |
Request Body
Mandatory
| Parameter | Type | Description |
|---|---|---|
| data | Object | Object containing one or more other single level objects, or primitive type arrays. See examples for more information. Each property defines a dataset that will form a part of the join. |
Common
Further Documentation: Common Parameters
| Parameter | Type | Description |
|---|---|---|
| filter | String | A fully functioning SQL based WHERE statement that will filter the outgoing dataset to the records it determines as being included. |
| sortOrder | Object | Sorts the resulting dataset by the criteria provided. The object should contain property names that represent properties contained within the resulting dataset with a value corresponding to the desired sort direction (i.e. ASC or DESC). |
| schema | Object | You can use this parameter to override the inferred schema for properties in the incoming dataset(s). A field will be inferred unless specific explicitly within this object. |
| advancedOptions | Object | Is an object with the following properties. cultureName (String) The specified culture determines the behaviour for aspects related to formatting numeric values and dates. Is extremely important when converting strings to dates, e.g. 05/03/2022 will be treated differently between locales. For more information on the accepted values for this property, please consult the documentation from Microsoft … https://docs.microsoft.com/en-us/dotnet/api/system.globalization.cultureinfo?view=net-6.0#culture-names-and-identifiers isBoolean (string[]) A list of strings that are the names of all properties in the resulting dataset that should be treated as boolean values. By default, the framework treats boolean values as 1 (true) or 0 (false). In order to differentiate the integer as a boolean, the property in question needs to be called out explicitly in this list. |
Examples
Simple
Complex
Three datasets all defined as a basic primitive array of numeric values.
Request
{
"Data": {
"Table1": [
1,
2,
3
],
"Table2": [
1,
2,
3,
4,
5
],
"Table3": [
1,
2
]
}
}
Code language: JSON / JSON with Comments (json)Response
[
{
"Table1": 1,
"Table2": 1,
"Table3": 1
},
{
"Table1": 1,
"Table2": 1,
"Table3": 2
},
{
"Table1": 1,
"Table2": 2,
"Table3": 1
},
{
"Table1": 1,
"Table2": 2,
"Table3": 2
},
{
"Table1": 1,
"Table2": 3,
"Table3": 1
},
{
"Table1": 1,
"Table2": 3,
"Table3": 2
},
{
"Table1": 1,
"Table2": 4,
"Table3": 1
},
{
"Table1": 1,
"Table2": 4,
"Table3": 2
},
{
"Table1": 1,
"Table2": 5,
"Table3": 1
},
{
"Table1": 1,
"Table2": 5,
"Table3": 2
},
{
"Table1": 2,
"Table2": 1,
"Table3": 1
},
{
"Table1": 2,
"Table2": 1,
"Table3": 2
},
{
"Table1": 2,
"Table2": 2,
"Table3": 1
},
{
"Table1": 2,
"Table2": 2,
"Table3": 2
},
{
"Table1": 2,
"Table2": 3,
"Table3": 1
},
{
"Table1": 2,
"Table2": 3,
"Table3": 2
},
{
"Table1": 2,
"Table2": 4,
"Table3": 1
},
{
"Table1": 2,
"Table2": 4,
"Table3": 2
},
{
"Table1": 2,
"Table2": 5,
"Table3": 1
},
{
"Table1": 2,
"Table2": 5,
"Table3": 2
},
{
"Table1": 3,
"Table2": 1,
"Table3": 1
},
{
"Table1": 3,
"Table2": 1,
"Table3": 2
},
{
"Table1": 3,
"Table2": 2,
"Table3": 1
},
{
"Table1": 3,
"Table2": 2,
"Table3": 2
},
{
"Table1": 3,
"Table2": 3,
"Table3": 1
},
{
"Table1": 3,
"Table2": 3,
"Table3": 2
},
{
"Table1": 3,
"Table2": 4,
"Table3": 1
},
{
"Table1": 3,
"Table2": 4,
"Table3": 2
},
{
"Table1": 3,
"Table2": 5,
"Table3": 1
},
{
"Table1": 3,
"Table2": 5,
"Table3": 2
}
]
Code language: JSON / JSON with Comments (json)Four datasets, two defined as a basic primitive array of numeric values and the other two defined as a more complex object based array with multiple properties.
The two complex datasets look the same but with different underlying data. Because of that and to remove issues relating to ambiguity, the data is returned with the dataset name prefixing each property.
Sorting applied on both a primitive dataset as well as the complex dataset. The sorting on DocumentNumber requires that the property be defined as the fully qualified name, failure to do this will lead to an error.
Request
{
"SortOrder": {
"Table1": "ASC",
"Header1.DocumentNumber": "ASC"
},
"Data": {
"Table1": [
1,
2,
3,
4,
5
],
"Header1": [
{
"DocumentNumber": "00001",
"CompanyCode": "1000",
"FiscalYear": "2019"
},
{
"DocumentNumber": "00002",
"CompanyCode": "1000",
"FiscalYear": "2019"
},
{
"DocumentNumber": "00001",
"CompanyCode": "2000",
"FiscalYear": "2020"
}
],
"Header2": [
{
"DocumentNumber": "00001",
"CompanyCode": "1000",
"FiscalYear": "2022"
},
{
"DocumentNumber": "00002",
"CompanyCode": "1000",
"FiscalYear": "2022"
},
{
"DocumentNumber": "00001",
"CompanyCode": "2000",
"FiscalYear": "2022"
}
],
"Table3": [
1,
2,
3,
4
]
}
}
Code language: JSON / JSON with Comments (json)Response
[
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 1,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 2,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 3,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 4,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00001",
"Header1.CompanyCode": "2000",
"Header1.FiscalYear": "2020",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00002",
"Header2.CompanyCode": "1000",
"Header2.FiscalYear": "2022",
"Table3": 4
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 1
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 2
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 3
},
{
"Table1": 5,
"Header1.DocumentNumber": "00002",
"Header1.CompanyCode": "1000",
"Header1.FiscalYear": "2019",
"Header2.DocumentNumber": "00001",
"Header2.CompanyCode": "2000",
"Header2.FiscalYear": "2022",
"Table3": 4
}
]
Code language: JSON / JSON with Comments (json)