2 Answers
- Newest
- Most votes
- Most comments
1
Hi, The Scan command you are looking for looks like this:
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state'
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state'
[
[
{
"S": "confirmed"
},
{
"S": "active"
},
{
"S": "finished"
},
{
"S": "archived"
}
]
]
Or you can narrow it down further with:
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state.S' --output text
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state.S' --output text
confirmed active finished archived
0
Thank you! Exactly what I needed! 👍 I modified it slightly, so that the output in the text is easy to process via Excel:
...,(stateHistory.L[0].M.state.S),(stateHistory.L[1].M.state.S),(stateHistory.L[2].M.state.S),(stateHistory.L[3].M.state.S),(stateHistory.L[4].M.state.S)]" --output text> data.txt
Follow-up question: How do I add headlines to each data field of the data.txt automatically so that I can use them as column names in Excel afterwards? 🤔
answered 2 years ago
Relevant content
- asked 9 months ago
- asked 2 years ago
- asked 7 months ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago